﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //Literal lt = new Literal();
        //lt.Text = "<img src=" + Request.QueryString["imagepath"].ToString() + " class=fotoEtiket alt=/>";
        //Image.Controls.Add(lt);

        //rpCihazlar.DataSource = db.DTGetir("Select * from Cihazlar C,FotoEtiket F Where F.Cihaz_ID <> C.Cihaz_ID");
        //rpCihazlar.DataBind();
        
        rpEtiketler.DataSource = db.DTGetir("Select * from Cihazlar C,FotoEtiket F Where F.Cihaz_ID = C.Cihaz_ID Order By F.Cihaz_ID Desc");
            //"Select fe.*,case when Cihaz_ID=0 Then fe.Etiket else (select Cihaz_Adi from Cihazlar where Cihaz_ID=fe.Cihaz_ID) end as 'FotoEtiket' from FotoEtiket as fe order by Cihaz_ID desc");
        rpEtiketler.DataBind();
    }
}
